SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_SR_SQL_GetReportRoles
(
	@ReportID int
)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

  SELECT *
	FROM dbo.DnnProduct_SR_SQL_Reports_Roles
	WHERE ReportID = @ReportID
	ORDER BY RoleName
END
GO
